USE [Invoice]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Nhat Hoang
-- Create date: 31/03/2011
-- Description:	sp_SYS_GROUP_COMM_GetById
-- =============================================
CREATE PROCEDURE sp_SYS_GROUP_COMM_GetById
	@groupID int,
	@commandID int, 
	@functionID int
AS
BEGIN
	SELECT [GroupID]
		  ,[CommandID]
		  ,[FunctionID]
	FROM [SYS_GROUP_COMM]
	WHERE [GroupID] = @groupID AND [CommandID] = @commandID AND [FunctionID] = @functionID
END
GO
